Nested Transactions with Integrity Constraints
نویسندگان
چکیده
This paper presents a solution to check integrity constraints in database systems supporting nested transactions. Using nested transactions allows to introduce parallelism inside a transaction and to partially recover failing transactions by deening a hierarchy of sub-transactions. If a constraint is violated by some sub-transactions, it is possible to reach the validation of the nested transaction, even if some part of it had to be aborted. In our solution, (i) only constraints that might be violated are checked, (ii) constraints are checked as soon as possible during the execution of the nested transaction and (iii) as few sub-transactions as possible are aborted. We do not interfere with the execution control of nested transaction, and users do not have to add any control code in the deenition of constraints or of transactions. The main idea of our solution is to attach the checking of a constraint to the smallest common ancestor of the sub-transactions which could violate the constraint.
منابع مشابه
Checking Integrity Constraints in Multidatabase Systems with Nested Transactions
This paper proposes various strategies for the checking of integrity constraints in multidatabase systems which support nested transactions. The solution presented in 8] for centralized environments is extended. The principle of this solution consists of designating a sub-transaction which controls the checking of each integrity constraint. This sub-transaction is the smallest common ancestor (...
متن کاملIntegrity Checking for Nested Transactions
In this paper, we present a mechanism to specify and to validate consistency constraints in object oriented databases. Constraints are speciied using pre and post-conditions associated with an exception handling mechanism. During transaction run-time, we treat exceptions corresponding to errors (in this case, we use immediate exceptions which are processed immediately) or presumption of errors ...
متن کاملIntegrity Constraint Checking in Distributed Nested Transactions over a Database Cluster
This paper presents a solution to check referential integrity constraints and conjunctive global constraints in a relational multi database system. It also presents the experimental results obtained by implementing this solution over a PC cluster with Oracle9i DBMS. The goal of those experimentations is to measure the time spent to check global constraints in a distributed systems. The results ...
متن کاملNested Transaction: An Efficient Facility to Enforce the Nesting and the Partial Ordering Requirements in S-Store
The goal of this thesis is to design and implement an efficient facility to enforce the nesting and the partial ordering requirements of transactions in S-Store [1], the world’s first streaming OLTP engine for real-time applications. We first compare and contrast different approaches to enforce these requirements, and conclude that nested transaction stands out both in terms of data integrity g...
متن کاملShould integrity constraints be global or local?
Data base integrity constraints are commonly expressed as predicates over data base states or state changes (global constraints) or as preconditions of transactions that are to change data base states (local constraints). We argue that business reengineering, and the lack of sophistication of users favor local constraints, but that global constraints may also be necessary. Local constraints are...
متن کامل